package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpParameters;

/**
 * <p>
 * 轮胎参数表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-12
 */
public interface ErpParametersMapper extends BaseMapper<ErpParameters> {
	@Select("select MAX(p.lines_s) from erp_parameters p where p.arand=#{arand} and p.norms=#{norms} and p.model=#{model} and p.address=#{address}")
	public String selectMaxLines(@Param("arand")String arand,@Param("norms")String norms,@Param("model")String model,@Param("address")String address);
	
	@Select("SELECT * from erp_parameters p where p.arand=#{arand} and p.norms=#{norms} and p.model=#{model} and p.address=#{address}")
	public List<ErpParameters> selectByArandAndNormsAndModelAndAddress(@Param("arand")String arand,@Param("norms")String norms,@Param("model")String model,@Param("address")String address);
}
